﻿using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Model
{
    public class BillingModel:BaseModel
    {
        public const string TABLE_NAME = "Billing";

        public BillingModel()
            : base(TABLE_NAME)
        {
            
        }

        public void InsertUpdateBillingAddress(int AccountId, int UserId, int BillingId, string CompanyName, string Email, string Phone, string Address, string Street1, string Street2, string City, string StateCode, string Country, string ZipCode)
        {
            ExecuteNonDataQuery("InsertUpdateBillingAddress", AccountId, UserId, BillingId, CompanyName, Email, Phone, Address, Street1, Street2, City, StateCode, Country, ZipCode);
        }

        public void InsertUpdateBillingAddressById(int BillingId, string CompanyName, string Email, string Phone, string Address, string Street1, string Street2, string City, string StateCode, string Country, string ZipCode)
        {
            ExecuteNonDataQuery("InsertUpdateBillingAddressById", BillingId, CompanyName, Email, Phone, Address, Street1, Street2, City, StateCode, Country, ZipCode);
        }

        public DataTable GetAddressInfoBilling(int AccountId, int UserId, int BillingId)
        {
            return GetDataTable("GetAddressInfoBilling", AccountId, UserId, BillingId);
        }

        public DataTable GetAddressInfoBillingById(int BillingId)
        {
            return GetDataTable("GetAddressInfoBillingById", BillingId);
        }
    }
}
